package com.lichunsheng.stu.dao;

import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.Set;


/**
 * (PePermission)表数据库访问层
 *
 * @author makejava
 * @since 2021-01-02 16:48:49
 */
public interface PePermissionDao extends Mapper<entity.PePermission> {

    @Select("SELECT\n" +
            "\t* \n" +
            "FROM\n" +
            "\tpe_permission AS pp\n" +
            "\tINNER JOIN pe_role_permission AS prp ON pp.id = prp.role_id \n" +
            "WHERE\n" +
            "\tprp.role_id = #{id} ")
    Set<String> findByRoleId(String id);

}